Skip to main content

INDEX SKIP SCAN

Short Description

The INDEX SKIP SCAN allows a composite index to be scanned for values not in the leading edge of the index.

Detailed Description​

INDEX SKIP SCAN allows a composite index to be scanned for values, where the values are not in the column at the leading edge of the index.

Using this method can reduce the number of indexes required to support a range of queries, which in turn can improve insert performance as there are less indexes to maintain.

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.